---
title: DB-CLL-051 — Retrieve the full legal case list
summary: Retrieve the full legal case list
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-051 — Retrieve the full legal case list

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-051 |
| Operation type | R |
| Execution method | Text |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Inline text SQL |
| Business object | clsLegalCaseCollection |
| Criteria property | RetrieveSQL |
| Lifecycle method | BeforeRetrieve |

## Parameters

No bound parameters were identified for this statement.

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [LEGAL_CASE](../database-tables.md#legal_case) | SELECT | all rows, no filter (inferred*) |

## Sample SQL

```sql
Select
  LEGAL_CASE.LEGAL_CASE_SEQ_NUM as LegalCaseID,
  LEGAL_CASE.CLAIM_ID as ClaimID,
  LEGAL_CASE.CASE_STATUS_CODE as CaseStatusCode
From
  LEGAL_CASE
```

## Operations and processes

- [Manage legal case lifecycle](../operations/manage-legal-case.md)

## Business rules

- [BR-CLM-LGL-005](../business-rules.md#br-clm-lgl-005-non-single-row-crud-result-is-treated-as-a-failure)

## Sources

- `SAIF.Business.Claim.Legal\clsLegalCaseCollection.vb`